ODAC

TSmartQuery Members

TSmartQuery class overview.

Properties

Name Description

BaseSQL (inherited from TCustomDADataSet)

 Used to return SQL text without any changes performed by AddWhere, SetOrderBy, and FilterSQL.

CachedUpdates (inherited from TMemDataSet)

 Used to enable or disable the use of cached updates for a dataset.

ChangeNotification (inherited from TOraDataSet)

 Used to receive database change notification messages to refresh dataset when required.

CheckMode (inherited from TOraDataSet)

 Used to define the check mode before editing a record.

CommandTimeout (inherited from TOraDataSet)

 Sets the wait time before a request is sent to the server to terminate the attempt to execute or fetch the current SQL statement.

Conditions (inherited from TCustomDADataSet)

 Used to add WHERE conditions to a query

Connection (inherited from TCustomDADataSet)

 Used to specify a connection object to use to connect to a data store.

Cursor (inherited from TOraDataSet)

 Used to fetch data from the cursor parameter and cursor field in Oracle 8.

DataTypeMap (inherited from TCustomDADataSet)

 Used to set data type mapping rules

Debug (inherited from TCustomDADataSet)

 Used to display the statement that is being executed and the values and types of its parameters.

DependEvents (inherited from TCustomSmartQuery)

 Used to get or set the names of the events that dataset will depend on in TCustomSmartQuery.SmartRefresh mode.

DetailFields (inherited from TCustomDADataSet)

 Used to specify the fields that correspond to the foreign key fields from MasterFields when building master/detail relationship.

Disconnected (inherited from TCustomDADataSet)

 Used to keep dataset opened after connection is closed.

DMLRefresh (inherited from TOraDataSet)

 Used to refresh record by RETURNING clause when insert or update is performed.

Encryption (inherited from TOraDataSet)

 Used to specify encryption options in a dataset.

Expand (inherited from TCustomSmartQuery)

 Lets all data controls be aware of all the fields belonging to updating table.

FetchAll (inherited from TOraDataSet)

 Used to request all records of the query from database server when a dataset is being opened.

FetchRows (inherited from TCustomDADataSet)

 Used to define the number of rows to be transferred across the network at the same time.

FilterSQL (inherited from TCustomDADataSet)

 Used to change the WHERE clause of SELECT statement and reopen a query.

FinalSQL (inherited from TCustomDADataSet)

 Used to return SQL text with all changes performed by AddWhere, SetOrderBy, and FilterSQL, and with expanded macros.

IndexFieldNames (inherited from TMemDataSet)

 Used to get or set the list of fields on which the recordset is sorted.

IsPLSQL (inherited from TOraDataSet)

 Indicates whether a SQL statement is a PL/SQL block.

IsQuery (inherited from TOraDataSet)

 Indicates whether SQL statement returns rows or not.

KeyExclusive (inherited from TMemDataSet)

 Specifies the upper and lower boundaries for a range.

KeyFields (inherited from TOraDataSet)

 Used to build SQL statements for the SQLDelete, SQLInsert, and SQLUpdate properties if they were empty before updating a database.

KeySequence (inherited from TOraDataSet)

 Used to specify the name of a sequence that will be used to fill in a key field after a new record is inserted or posted to a database.

LocalConstraints (inherited from TMemDataSet)

 Used to avoid setting the Required property of a TField component for NOT NULL fields at the time of opening TMemDataSet.

LocalUpdate (inherited from TMemDataSet)

 Used to prevent implicit update of rows on database server.

LockMode (inherited from TOraDataSet)

 Used to define when to perform the locking of an editing record.

MacroCount (inherited from TCustomDADataSet)

 Used to get the number of macros associated with the Macros property.

Macros (inherited from TCustomDADataSet)

 Makes it possible to change SQL queries easily.

MasterFields (inherited from TCustomDADataSet)

 Used to specify the names of one or more fields that are used as foreign keys for dataset when establishing detail/master relationship between it and the dataset specified in MasterSource.

MasterSource (inherited from TCustomDADataSet)

 Used to specify the data source component which binds current dataset to the master one.

NonBlocking (inherited from TOraDataSet)

 Used to execute a SQL statement and fetch rows by a separate thread.

Options (inherited from TCustomSmartQuery)

 Used to specify the behaviour of TCustomSmartQuery object.

OptionsDS (inherited from TOraDataSet)

 Used to specify the behaviour of TOraDataSetObject.

ParamCheck (inherited from TCustomDADataSet)

 Used to specify whether parameters for the Params property are generated automatically after the SQL property was changed.

ParamCount (inherited from TCustomDADataSet)

 Used to indicate how many parameters are there in the Params property.

Params (inherited from TOraDataSet)

 Contains the parameters for a query's SQL statement.

Prepared (inherited from TMemDataSet)

 Determines whether a query is prepared for execution or not.

Ranged (inherited from TMemDataSet)

 Indicates whether a range is applied to a dataset.

ReadOnly (inherited from TCustomDADataSet)

 Used to prevent users from updating, inserting, or deleting data in the dataset.

RefreshEvent (inherited from TCustomSmartQuery)

 Used to get or set the name of the event that dataset will be waiting for in TCustomSmartQuery.SmartRefresh mode.

RefreshMode (inherited from TOraDataSet)

 Used to specify when to refresh an editing record.

RefreshOptions (inherited from TCustomDADataSet)

 Used to indicate when the editing record is refreshed.

ReturnParams (inherited from TOraDataSet)

 Used to return a new fields value to dataset after insert or update.

RowsAffected (inherited from TCustomDADataSet)

 Used to indicate the number of rows which were inserted, updated, or deleted during the last query operation.

RowsProcessed (inherited from TOraDataSet)

 Returns the number of rows processed by a query.

SequenceMode (inherited from TOraDataSet)

 Used to specify the methods used internally to generate a sequenced field.

Session (inherited from TOraDataSet)

 Used to specify the session in which dataset will be executed.

SmartFetch (inherited from TOraDataSet)

 The SmartFetch mode is used for fast navigation through a huge amount of records and to minimize memory consumption.

SmartRefresh (inherited from TCustomSmartQuery)

 Let TCustomSmartQuery components work in a concurrent environment.

SmartState (inherited from TCustomSmartQuery)

 Defines if TCustomSmartQuery is in view mode.

SQL (inherited from TCustomDADataSet)

 Used to provide a SQL statement that a query component executes when its Open method is called.

SQLDelete (inherited from TCustomDADataSet)

 Used to specify a SQL statement that will be used when applying a deletion to a record.

SQLInsert (inherited from TCustomDADataSet)

 Used to specify the SQL statement that will be used when applying an insertion to a dataset.

SQLLock (inherited from TCustomDADataSet)

 Used to specify a SQL statement that will be used to perform a record lock.

SQLRecCount (inherited from TCustomDADataSet)

 Used to specify the SQL statement that is used to get the record count when opening a dataset.

SQLRefresh (inherited from TCustomDADataSet)

 Used to specify a SQL statement that will be used to refresh current record by calling the TCustomDADataSet.RefreshRecord procedure.

SQLType (inherited from TOraDataSet)

 Used to get the typecode of the SQL statement being processed by Oracle database server.

SQLUpdate (inherited from TCustomDADataSet)

 Used to specify a SQL statement that will be used when applying an update to a dataset.

StrictUpdate (inherited from TOraDataSet)

 Used for TOraDataSet to raise the 'Update failed' exception when the number of updated or deleted records are not equal to 1.

UniDirectional (inherited from TCustomDADataSet)

 Used if an application does not need bidirectional access to records in the result set.

UpdateObject (inherited from TOraDataSet)

 Used to specify an update object component which provides SQL statements that perform updates of the read-only datasets.

UpdateRecordTypes (inherited from TMemDataSet)

 Used to indicate the update status for the current record when cached updates are enabled.

UpdatesPending (inherited from TMemDataSet)

 Used to check the status of the cached updates buffer.

Methods

Name Description

AddWhere (inherited from TCustomDADataSet)

 Adds condition to the WHERE clause of SELECT statement in the SQL property.

ApplyRange (inherited from TMemDataSet)

 Applies a range to the dataset.

ApplyUpdates (inherited from TMemDataSet)

 Overloaded. Writes dataset's pending cached updates to a database.

BreakExec (inherited from TCustomDADataSet)

 Breaks execution of a SQL statement on the server.

CancelRange (inherited from TMemDataSet)

 Removes any ranges currently in effect for a dataset.

CancelUpdates (inherited from TMemDataSet)

 Clears all pending cached updates from cache and restores dataset in its prior state.

CloneCursor (inherited from TCustomDADataSet)

 Shares data from another dataset.

CommitUpdates (inherited from TMemDataSet)

 Clears the cached updates buffer.

CreateBlobStream (inherited from TCustomDADataSet)

 Used to obtain a stream for reading data from or writing data to a BLOB field, specified by the Field parameter.

CreateProcCall (inherited from TOraDataSet)

 Generates the stored procedure call.

DeferredPost (inherited from TMemDataSet)

 Makes permanent changes to the database server.

DeleteWhere (inherited from TCustomDADataSet)

 Removes WHERE clause from the SQL property and assigns the BaseSQL property.

EditRangeEnd (inherited from TMemDataSet)

 Enables changing the ending value for an existing range.

EditRangeStart (inherited from TMemDataSet)

 Enables changing the starting value for an existing range.

ErrorOffset (inherited from TOraDataSet)

 Returns the parse error offset.

Execute (inherited from TCustomDADataSet)

 Overloaded. Executes a SQL statement on the server.

Executing (inherited from TCustomDADataSet)

 Indicates whether SQL statement is still being executed.

Fetched (inherited from TCustomDADataSet)

 Used to find out whether TCustomDADataSet has fetched all rows.

Fetching (inherited from TCustomDADataSet)

 Used to learn whether TCustomDADataSet is still fetching rows.

FetchingAll (inherited from TCustomDADataSet)

 Used to learn whether TCustomDADataSet is fetching all rows to the end.

FindKey (inherited from TCustomDADataSet)

 Searches for a record which contains specified field values.

FindMacro (inherited from TCustomDADataSet)

 Finds a macro with the specified name.

FindNearest (inherited from TCustomDADataSet)

 Moves the cursor to a specific record or to the first record in the dataset that matches or is greater than the values specified in the KeyValues parameter.

FindParam (inherited from TOraDataSet)

 Determines whether a parameter with the specified name exists in a dataset.

GetArray (inherited from TOraDataSet)

 Retrieves a TOraArray object for a field when only its name is known.

GetBlob (inherited from TMemDataSet)

 Overloaded. Retrieves TBlob object for a field or current record when only its name or the field itself is known.

GetDataType (inherited from TCustomDADataSet)

 Returns internal field types defined in the MemData and accompanying modules.

GetErrorPos (inherited from TOraDataSet)

 Returns a row and column of parse error for a SQL statement.

GetFieldObject (inherited from TCustomDADataSet)

 Returns a multireference shared object from field.

GetFieldPrecision (inherited from TCustomDADataSet)

 Retrieves the precision of a number field.

GetFieldScale (inherited from TCustomDADataSet)

 Retrieves the scale of a number field.

GetFile (inherited from TOraDataSet)

 Retrieves a TOraFile object for a field with known name.

GetInterval (inherited from TOraDataSet)

 Retrieves a TOraInterval object for a field with known name.

GetKeyFieldNames (inherited from TCustomDADataSet)

 Provides a list of available key field names.

GetKeyList (inherited from TOraDataSet)

 Returns the list of table primary key fields.

GetLob (inherited from TOraDataSet)

 Retrieves a TOraLob object for a field with known name.

GetLobLocator (inherited from TOraDataSet)

 Retrieves a TOraLob object for a field with known name.

GetObject (inherited from TOraDataSet)

 Retrieves a TOraObject object for a field with known name.

GetOrderBy (inherited from TCustomDADataSet)

 Retrieves an ORDER BY clause from a SQL statement.

GetRef (inherited from TOraDataSet)

 Retrieves a TOraRef object for a field with known name.

GetTable (inherited from TOraDataSet)

 Retrieve a TOraNestTable object for a field with known name.

GetTimeStamp (inherited from TOraDataSet)

 Retrieves a TOraTimeStamp object for a field with known name.

GotoCurrent (inherited from TCustomDADataSet)

 Sets the current record in this dataset similar to the current record in another dataset.

Locate (inherited from TMemDataSet)

 Overloaded. Searches a dataset for a specific record and positions the cursor on it.

LocateEx (inherited from TMemDataSet)

 Overloaded. Excludes features that don't need to be included to the TMemDataSet.Locate method of TDataSet.

Lock (inherited from TCustomDADataSet)

 Locks the current record.

MacroByName (inherited from TCustomDADataSet)

 Finds a macro with the specified name.

OpenNext (inherited from TOraDataSet)

 Opens next cursor or rowset in the statement.

ParamByName (inherited from TOraDataSet)

 Sets or uses parameter information for a specific parameter based on its name.

Prepare (inherited from TCustomDADataSet)

 Allocates, opens, and parses cursor for a query.

RefreshRecord (inherited from TCustomDADataSet)

 Actualizes field values for the current record.

RestoreSQL (inherited from TCustomDADataSet)

 Restores the SQL property modified by AddWhere and SetOrderBy.

RestoreUpdates (inherited from TMemDataSet)

 Marks all records in the cache of updates as unapplied.

RevertRecord (inherited from TMemDataSet)

 Cancels changes made to the current record when cached updates are enabled.

SaveSQL (inherited from TCustomDADataSet)

 Saves the SQL property value to BaseSQL.

SaveToXML (inherited from TMemDataSet)

 Overloaded. Saves the current dataset data to a file or a stream in the XML format compatible with ADO format.

SetOrderBy (inherited from TCustomDADataSet)

 Builds an ORDER BY clause of a SELECT statement.

SetRange (inherited from TMemDataSet)

 Sets the starting and ending values of a range, and applies it.

SetRangeEnd (inherited from TMemDataSet)

 Indicates that subsequent assignments to field values specify the end of the range of rows to include in the dataset.

SetRangeStart (inherited from TMemDataSet)

 Indicates that subsequent assignments to field values specify the start of the range of rows to include in the dataset.

SQLSaved (inherited from TCustomDADataSet)

 Determines if the SQL property value was saved to the BaseSQL property.

UnLock (inherited from TCustomDADataSet)

 Releases a record lock.

UnPrepare (inherited from TMemDataSet)

 Frees the resources allocated for a previously prepared query on the server and client sides.

UpdateResult (inherited from TMemDataSet)

 Reads the status of the latest call to the ApplyUpdates method while cached updates are enabled.

UpdateStatus (inherited from TMemDataSet)

 Indicates the current update status for the dataset when cached updates are enabled.

View (inherited from TCustomSmartQuery)

 Allows viewing all fields of the updating table.

Events

Name Description

AfterExecute (inherited from TCustomDADataSet)

 Occurs after a component has executed a query to database.

AfterFetch (inherited from TCustomDADataSet)

 Occurs after dataset finishes fetching data from server.

AfterSmartRefresh (inherited from TCustomSmartQuery)

 Occurs after the Smart Refresh procedure was performed by TCustomOraQuery.

AfterUpdateExecute (inherited from TCustomDADataSet)

 Occurs after executing insert, delete, update, lock and refresh operations.

BeforeFetch (inherited from TCustomDADataSet)

 Occurs before dataset is going to fetch block of records from the server.

BeforeUpdateExecute (inherited from TCustomDADataSet)

 Occurs before executing insert, delete, update, lock, and refresh operations.

OnUpdateError (inherited from TMemDataSet)

 Occurs when an exception is generated while cached updates are applied to a database.

OnUpdateRecord (inherited from TMemDataSet)

 Occurs when a single update component can not handle the updates.

RefreshFields (inherited from TCustomSmartQuery)

 Occures before an application posts changes for the current record to the database or cache.
© 1997-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback